class CreateSchema < ActiveRecord::Migration[4.2]
  # rubocop:disable Metrics/AbcSize, Metrics/MethodLength, Metrics/LineLength, Layout/ExtraSpacing
  def up
    create_table :account_deletions do |t|
      t.string  :diaspora_handle
      t.integer :person_id
    end

    create_table :aspect_memberships do |t|
      t.integer  :aspect_id,  null: false
      t.integer  :contact_id, null: false
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    add_index :aspect_memberships, %i[aspect_id contact_id], name: :index_aspect_memberships_on_aspect_id_and_contact_id, unique: true
    add_index :aspect_memberships, [:aspect_id], name: :index_aspect_memberships_on_aspect_id
    add_index :aspect_memberships, [:contact_id], name: :index_aspect_memberships_on_contact_id

    create_table :aspect_visibilities do |t|
      t.integer  :shareable_id,                    null: false
      t.integer  :aspect_id,                       null: false
      t.datetime :created_at,                      null: false
      t.datetime :updated_at,                      null: false
      t.string   :shareable_type, default: "Post", null: false
    end

    add_index :aspect_visibilities, [:aspect_id], name: :index_aspect_visibilities_on_aspect_id
    add_index :aspect_visibilities, %i[shareable_id shareable_type aspect_id], name: :shareable_and_aspect_id, length: {shareable_type: 189}, using: :btree
    add_index :aspect_visibilities, %i[shareable_id shareable_type], name: :index_aspect_visibilities_on_shareable_id_and_shareable_type, length: {shareable_type: 190}, using: :btree

    create_table :aspects do |t|
      t.string   :name,                            null: false
      t.integer  :user_id,                         null: false
      t.datetime :created_at,                      null: false
      t.datetime :updated_at,                      null: false
      t.boolean  :contacts_visible, default: true, null: false
      t.integer  :order_id
    end

    add_index :aspects, %i[user_id contacts_visible], name: :index_aspects_on_user_id_and_contacts_visible
    add_index :aspects, [:user_id], name: :index_aspects_on_user_id

    create_table :blocks do |t|
      t.integer :user_id
      t.integer :person_id
    end

    create_table :comments do |t|
      t.text     :text,                                               null: false
      t.integer  :commentable_id,                                     null: false
      t.integer  :author_id,                                          null: false
      t.string   :guid,                                               null: false
      t.text     :author_signature
      t.text     :parent_author_signature
      t.datetime :created_at,                                         null: false
      t.datetime :updated_at,                                         null: false
      t.integer  :likes_count,                       default: 0,      null: false
      t.string   :commentable_type,       limit: 60, default: "Post", null: false
    end

    add_index :comments, [:author_id], name: :index_comments_on_person_id
    add_index :comments, %i[commentable_id commentable_type], name: :index_comments_on_commentable_id_and_commentable_type
    add_index :comments, [:guid], name: :index_comments_on_guid, length: {guid: 191}, using: :btree, unique: true

    create_table :contacts do |t|
      t.integer  :user_id,                    null: false
      t.integer  :person_id,                  null: false
      t.datetime :created_at,                 null: false
      t.datetime :updated_at,                 null: false
      t.boolean  :sharing,    default: false, null: false
      t.boolean  :receiving,  default: false, null: false
    end

    add_index :contacts, [:person_id], name: :index_contacts_on_person_id
    add_index :contacts, %i[user_id person_id], name: :index_contacts_on_user_id_and_person_id, unique: true

    create_table :conversation_visibilities do |t|
      t.integer  :conversation_id,             null: false
      t.integer  :person_id,                   null: false
      t.integer  :unread,          default: 0, null: false
      t.datetime :created_at,                  null: false
      t.datetime :updated_at,                  null: false
    end

    add_index :conversation_visibilities, %i[conversation_id person_id], name: :index_conversation_visibilities_usefully, unique: true
    add_index :conversation_visibilities, [:conversation_id], name: :index_conversation_visibilities_on_conversation_id
    add_index :conversation_visibilities, [:person_id], name: :index_conversation_visibilities_on_person_id

    create_table :conversations do |t|
      t.string   :subject
      t.string   :guid,       null: false
      t.integer  :author_id,  null: false
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    add_index :conversations, [:author_id], name: :conversations_author_id_fk

    create_table :invitation_codes do |t|
      t.string   :token
      t.integer  :user_id
      t.integer  :count
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    create_table :invitations do |t|
      t.text     :message
      t.integer  :sender_id
      t.integer  :recipient_id
      t.integer  :aspect_id
      t.datetime :created_at,                   null: false
      t.datetime :updated_at,                   null: false
      t.string   :service
      t.string   :identifier
      t.boolean  :admin,        default: false
      t.string   :language,     default: "en"
    end

    add_index :invitations, [:aspect_id], name: :index_invitations_on_aspect_id
    add_index :invitations, [:recipient_id], name: :index_invitations_on_recipient_id
    add_index :invitations, [:sender_id], name: :index_invitations_on_sender_id

    create_table :likes do |t|
      t.boolean  :positive,                           default: true
      t.integer  :target_id
      t.integer  :author_id
      t.string   :guid
      t.text     :author_signature
      t.text     :parent_author_signature
      t.datetime :created_at,                                        null: false
      t.datetime :updated_at,                                        null: false
      t.string   :target_type,             limit: 60,                null: false
    end

    add_index :likes, [:author_id], name: :likes_author_id_fk
    add_index :likes, [:guid], name: :index_likes_on_guid, length: {guid: 191}, using: :btree, unique: true
    add_index :likes, %i[target_id author_id target_type], name: :index_likes_on_target_id_and_author_id_and_target_type, unique: true
    add_index :likes, [:target_id], name: :index_likes_on_post_id

    create_table :locations do |t|
      t.string   :address
      t.string   :lat
      t.string   :lng
      t.integer  :status_message_id
      t.datetime :created_at,        null: false
      t.datetime :updated_at,        null: false
    end

    create_table :mentions do |t|
      t.integer :post_id,   null: false
      t.integer :person_id, null: false
    end

    add_index :mentions, %i[person_id post_id], name: :index_mentions_on_person_id_and_post_id, unique: true
    add_index :mentions, [:person_id], name: :index_mentions_on_person_id
    add_index :mentions, [:post_id], name: :index_mentions_on_post_id

    create_table :messages do |t|
      t.integer  :conversation_id,         null: false
      t.integer  :author_id,               null: false
      t.string   :guid,                    null: false
      t.text     :text,                    null: false
      t.datetime :created_at,              null: false
      t.datetime :updated_at,              null: false
      t.text     :author_signature
      t.text     :parent_author_signature
    end

    add_index :messages, [:author_id], name: :index_messages_on_author_id
    add_index :messages, [:conversation_id], name: :messages_conversation_id_fk

    create_table :notification_actors do |t|
      t.integer  :notification_id
      t.integer  :person_id
      t.datetime :created_at,      null: false
      t.datetime :updated_at,      null: false
    end

    add_index :notification_actors, %i[notification_id person_id], name: :index_notification_actors_on_notification_id_and_person_id, unique: true
    add_index :notification_actors, [:notification_id], name: :index_notification_actors_on_notification_id
    add_index :notification_actors, [:person_id], name: :index_notification_actors_on_person_id

    create_table :notifications do |t|
      t.string   :target_type
      t.integer  :target_id
      t.integer  :recipient_id,                null: false
      t.boolean  :unread,       default: true, null: false
      t.datetime :created_at,                  null: false
      t.datetime :updated_at,                  null: false
      t.string   :type
    end

    add_index :notifications, [:recipient_id], name: :index_notifications_on_recipient_id
    add_index :notifications, [:target_id], name: :index_notifications_on_target_id
    add_index :notifications, %i[target_type target_id], name: :index_notifications_on_target_type_and_target_id, length: {target_type: 190}, using: :btree

    create_table :o_embed_caches do |t|
      t.string :url,  limit: 1024, null: false
      t.text   :data,              null: false
    end

    add_index :o_embed_caches, [:url], name: :index_o_embed_caches_on_url, length: {url: 191}, using: :btree

    create_table :participations do |t|
      t.string   :guid
      t.integer  :target_id
      t.string   :target_type,             limit: 60, null: false
      t.integer  :author_id
      t.text     :author_signature
      t.text     :parent_author_signature
      t.datetime :created_at,                         null: false
      t.datetime :updated_at,                         null: false
    end

    add_index :participations, [:guid], name: :index_participations_on_guid, length: {guid: 191}, using: :btree
    add_index :participations, %i[target_id target_type author_id], name: :index_participations_on_target_id_and_target_type_and_author_id

    create_table :people do |t|
      t.string   :guid,                                  null: false
      t.text     :url,                                   null: false
      t.string   :diaspora_handle,                       null: false
      t.text     :serialized_public_key,                 null: false
      t.integer  :owner_id
      t.datetime :created_at,                            null: false
      t.datetime :updated_at,                            null: false
      t.boolean  :closed_account,        default: false
      t.integer  :fetch_status,          default: 0
    end

    add_index :people, [:diaspora_handle], name: :index_people_on_diaspora_handle, unique: true, length: {diaspora_handle: 191}
    add_index :people, [:guid], name: :index_people_on_guid, length: {guid: 191}, using: :btree, unique: true
    add_index :people, [:owner_id], name: :index_people_on_owner_id, unique: true

    create_table :photos do |t|
      t.integer  :tmp_old_id
      t.integer  :author_id,                           null: false
      t.boolean  :public,              default: false, null: false
      t.string   :diaspora_handle
      t.string   :guid,                                null: false
      t.boolean  :pending,             default: false, null: false
      t.text     :text
      t.text     :remote_photo_path
      t.string   :remote_photo_name
      t.string   :random_string
      t.string   :processed_image
      t.datetime :created_at
      t.datetime :updated_at
      t.string   :unprocessed_image
      t.string   :status_message_guid
      t.integer  :comments_count
      t.integer  :height
      t.integer  :width
    end

    add_index :photos, [:status_message_guid], name: :index_photos_on_status_message_guid, length: {status_message_guid: 191}, using: :btree

    create_table :pods do |t|
      t.string   :host
      t.boolean  :ssl
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    create_table :posts do |t|
      t.integer  :author_id,                                        null: false
      t.boolean  :public,                           default: false, null: false
      t.string   :diaspora_handle
      t.string   :guid,                                             null: false
      t.boolean  :pending,                          default: false, null: false
      t.string   :type,                  limit: 40,                 null: false
      t.text     :text
      t.text     :remote_photo_path
      t.string   :remote_photo_name
      t.string   :random_string
      t.string   :processed_image
      t.datetime :created_at,                                       null: false
      t.datetime :updated_at,                                       null: false
      t.string   :unprocessed_image
      t.string   :object_url
      t.string   :image_url
      t.integer  :image_height
      t.integer  :image_width
      t.string   :provider_display_name
      t.string   :actor_url
      t.string   :objectId
      t.string   :root_guid,             limit: 30
      t.string   :status_message_guid
      t.integer  :likes_count,                      default: 0
      t.integer  :comments_count,                   default: 0
      t.integer  :o_embed_cache_id
      t.integer  :reshares_count,                   default: 0
      t.datetime :interacted_at
      t.string   :frame_name
      t.boolean  :favorite,                         default: false
    end

    add_index :posts, %i[author_id root_guid], name: :index_posts_on_author_id_and_root_guid, length: {root_guid: 30}, using: :btree, unique: true
    add_index :posts, [:author_id], name: :index_posts_on_person_id
    add_index :posts, [:guid], name: :index_posts_on_guid, length: {guid: 191}, using: :btree, unique: true
    add_index :posts, %i[id type created_at], name: :index_posts_on_id_and_type_and_created_at
    add_index :posts, [:root_guid], name: :index_posts_on_root_guid, length: {root_guid: 30}
    add_index :posts, %i[status_message_guid pending], name: :index_posts_on_status_message_guid_and_pending, length: {status_message_guid: 190}, using: :btree
    add_index :posts, [:status_message_guid], name: :index_posts_on_status_message_guid, length: {status_message_guid: 191}, using: :btree
    add_index :posts, %i[type pending id], name: :index_posts_on_type_and_pending_and_id

    create_table :profiles do |t|
      t.string   :diaspora_handle
      t.string   :first_name,       limit: 127
      t.string   :last_name,        limit: 127
      t.string   :image_url
      t.string   :image_url_small
      t.string   :image_url_medium
      t.date     :birthday
      t.string   :gender
      t.text     :bio
      t.boolean  :searchable,                   default: true,  null: false
      t.integer  :person_id,                                    null: false
      t.datetime :created_at,                                   null: false
      t.datetime :updated_at,                                   null: false
      t.string   :location
      t.string   :full_name,        limit: 70
      t.boolean  :nsfw,                         default: false
    end

    add_index :profiles, %i[full_name searchable], name: :index_profiles_on_full_name_and_searchable
    add_index :profiles, [:full_name], name: :index_profiles_on_full_name
    add_index :profiles, [:person_id], name: :index_profiles_on_person_id

    create_table :rails_admin_histories do |t|
      t.text     :message
      t.string   :username
      t.integer  :item
      t.string   :table
      t.integer  :month,      limit: 2
      t.integer  :year,       limit: 8
      t.datetime :created_at,           null: false
      t.datetime :updated_at,           null: false
    end

    add_index :rails_admin_histories, %i[item table month year], name: :index_rails_admin_histories, length: {table: 188}

    create_table :roles do |t|
      t.integer  :person_id
      t.string   :name
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    create_table :services do |t|
      t.string   :type,          limit: 127, null: false
      t.integer  :user_id,                   null: false
      t.string   :uid,           limit: 127
      t.string   :access_token
      t.string   :access_secret
      t.string   :nickname
      t.datetime :created_at,                null: false
      t.datetime :updated_at,                null: false
    end

    add_index :services, %i[type uid], name: :index_services_on_type_and_uid, length: {type: 64, uid: 127}, using: :btree
    add_index :services, [:user_id], name: :index_services_on_user_id

    create_table :share_visibilities do |t|
      t.integer  :shareable_id,                               null: false
      t.datetime :created_at,                                 null: false
      t.datetime :updated_at,                                 null: false
      t.boolean  :hidden,                    default: false,  null: false
      t.integer  :contact_id,                                 null: false
      t.string   :shareable_type, limit: 60, default: "Post", null: false
    end

    add_index :share_visibilities, [:contact_id], name: :index_post_visibilities_on_contact_id
    add_index :share_visibilities, %i[shareable_id shareable_type contact_id], name: :shareable_and_contact_id
    add_index :share_visibilities, %i[shareable_id shareable_type hidden contact_id], name: :shareable_and_hidden_and_contact_id
    add_index :share_visibilities, [:shareable_id], name: :index_post_visibilities_on_post_id

    create_table :tag_followings do |t|
      t.integer  :tag_id,     null: false
      t.integer  :user_id,    null: false
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    add_index :tag_followings, %i[tag_id user_id], name: :index_tag_followings_on_tag_id_and_user_id, unique: true
    add_index :tag_followings, [:tag_id], name: :index_tag_followings_on_tag_id
    add_index :tag_followings, [:user_id], name: :index_tag_followings_on_user_id

    create_table :taggings do |t|
      t.integer  :tag_id
      t.integer  :taggable_id
      t.string   :taggable_type, limit: 127
      t.integer  :tagger_id
      t.string   :tagger_type,   limit: 127
      t.string   :context,       limit: 127
      t.datetime :created_at
    end

    add_index :taggings, [:created_at], name: :index_taggings_on_created_at
    add_index :taggings, [:tag_id], name: :index_taggings_on_tag_id
    add_index :taggings, %i[taggable_id taggable_type context], name: :index_taggings_on_taggable_id_and_taggable_type_and_context, length: {taggable_type: 95, context: 95}, using: :btree
    add_index :taggings, %i[taggable_id taggable_type tag_id], name: :index_taggings_uniquely, unique: true

    create_table :tags do |t|
      t.string :name
    end

    add_index :tags, [:name], name: :index_tags_on_name, unique: true, length: {name: 191}

    create_table :user_preferences do |t|
      t.string   :email_type
      t.integer  :user_id
      t.datetime :created_at, null: false
      t.datetime :updated_at, null: false
    end

    create_table :users do |t|
      t.string   :username
      t.text     :serialized_private_key
      t.boolean  :getting_started,                                default: true,  null: false
      t.boolean  :disable_mail,                                   default: false, null: false
      t.string   :language
      t.string   :email,                                          default: "",    null: false
      t.string   :encrypted_password,                             default: "",    null: false
      t.string   :invitation_token,                   limit: 60
      t.datetime :invitation_sent_at
      t.string   :reset_password_token
      t.datetime :remember_created_at
      t.integer  :sign_in_count,                                  default: 0
      t.datetime :current_sign_in_at
      t.datetime :last_sign_in_at
      t.string   :current_sign_in_ip
      t.string   :last_sign_in_ip
      t.datetime :created_at,                                                     null: false
      t.datetime :updated_at,                                                     null: false
      t.string   :invitation_service,                 limit: 127
      t.string   :invitation_identifier,              limit: 127
      t.integer  :invitation_limit
      t.integer  :invited_by_id
      t.string   :invited_by_type
      t.string   :authentication_token,               limit: 30
      t.string   :unconfirmed_email
      t.string   :confirm_email_token,                limit: 30
      t.datetime :locked_at
      t.boolean  :show_community_spotlight_in_stream,             default: true,  null: false
      t.boolean  :auto_follow_back,                               default: false
      t.integer  :auto_follow_back_aspect_id
      t.text     :hidden_shareables
      t.datetime :reset_password_sent_at
    end

    add_index :users, [:authentication_token], name: :index_users_on_authentication_token, unique: true
    add_index :users, [:email], name: :index_users_on_email, length: {email: 191}
    add_index :users, %i[invitation_service invitation_identifier], name: :index_users_on_invitation_service_and_invitation_identifier, length: {invitation_service: 64, invitation_identifier: 127}, using: :btree, unique: true
    add_index :users, [:invitation_token], name: :index_users_on_invitation_token
    add_index :users, [:username], name: :index_users_on_username, length: {username: 191}, using: :btree, unique: true

    add_foreign_key :aspect_memberships, :aspects, name: :aspect_memberships_aspect_id_fk, on_delete: :cascade
    add_foreign_key :aspect_memberships, :contacts, name: :aspect_memberships_contact_id_fk, on_delete: :cascade

    add_foreign_key :aspect_visibilities, :aspects, name: :aspect_visibilities_aspect_id_fk, on_delete: :cascade

    add_foreign_key :comments, :people, name: :comments_author_id_fk, column: :author_id, on_delete: :cascade

    add_foreign_key :contacts, :people, name: :contacts_person_id_fk, on_delete: :cascade

    add_foreign_key :conversation_visibilities, :conversations, name: :conversation_visibilities_conversation_id_fk, on_delete: :cascade
    add_foreign_key :conversation_visibilities, :people, name: :conversation_visibilities_person_id_fk, on_delete: :cascade

    add_foreign_key :conversations, :people, name: :conversations_author_id_fk, column: :author_id, on_delete: :cascade

    add_foreign_key :invitations, :users, name: :invitations_recipient_id_fk, column: :recipient_id, on_delete: :cascade
    add_foreign_key :invitations, :users, name: :invitations_sender_id_fk, column: :sender_id, on_delete: :cascade

    add_foreign_key :likes, :people, name: :likes_author_id_fk, column: :author_id, on_delete: :cascade

    add_foreign_key :messages, :conversations, name: :messages_conversation_id_fk, on_delete: :cascade
    add_foreign_key :messages, :people, name: :messages_author_id_fk, column: :author_id, on_delete: :cascade

    add_foreign_key :notification_actors, :notifications, name: :notification_actors_notification_id_fk, on_delete: :cascade

    add_foreign_key :posts, :people, name: :posts_author_id_fk, column: :author_id, on_delete: :cascade

    add_foreign_key :profiles, :people, name: :profiles_person_id_fk, on_delete: :cascade

    add_foreign_key :services, :users, name: :services_user_id_fk, on_delete: :cascade

    add_foreign_key :share_visibilities, :contacts, name: :post_visibilities_contact_id_fk, on_delete: :cascade
  end
  # rubocop:enable Metrics/AbcSize, Metrics/MethodLength, Metrics/LineLength, Layout/ExtraSpacing
end
